COUNT STOPKEY
Short Description
The number of rows returned is limited by the ROWNUM expression in the WHERE clause.
Detailed Description​
The number of rows returned is limited by the ROWNUM expression in the WHERE clause.
e.g.
SELECT * FROM t1
WHERE ROWNUM < 10;
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.